﻿CREATE TABLE [dbo].[DeptPrices] (
    [GoodsId]      INT             NOT NULL,
    [Price]        DECIMAL (19, 2) NOT NULL,
    [Count]        INT             NOT NULL,
    [DepartmentId] TINYINT         NOT NULL,
    CONSTRAINT [FK_DeptPrices_DeptPricesInfo] FOREIGN KEY ([DepartmentId]) REFERENCES [dbo].[DeptPricesInfo] ([DepartmentId]) ON DELETE CASCADE
);

